package com.pwt.repository;

import com.pwt.repository.base.BaseRepository;
import com.pwt.entity.WhatResult;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * WhatResult Repository层
 *
 * @author auto generated
 * @date 2021-09-04 11:50:49
 */
public interface WhatResultRepository extends BaseRepository<WhatResult, String> {


    @Query(nativeQuery = true,value = "select  * from what_result where [global] = 2 and create_by =?1")
    List<WhatResult> findByCreateBy(String createBy);

    List<WhatResult> findByGlobal(int global);
}
